package com.zhaopin.dao;

import com.zhaopin.common.DbBuilder;
import com.zhaopin.vo.UserVo;

import java.util.List;
import java.util.UUID;

public class QDao {
    public Integer count(){
        String token= UUID.randomUUID().toString();//创建一个永不重复的32位字符串
        String sql ="select count(*) from score";
        return DbBuilder.getCount(sql);
    }

    public List<UserVo> getUser(){
        String sql ="select a.id,a.user_name name,b.role_name roleName from t_user a,t_role b,t_user_role c where a.id=c.user_id and b.id=c.role_id";
        return DbBuilder.getListBean(sql,UserVo.class);
    }


}
